IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SrvrInstncSchedJobScheduleMSSQL]') AND type in (N'U'))
BEGIN
     DROP TABLE [dbo].[SrvrInstncSchedJobScheduleMSSQL]
END
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[SrvrInstncSchedJobScheduleMSSQL](
     [SrvrInstncId]             [int]              NOT NULL,
     [SrvrInstncSchedJobId]     [int]              NOT NULL,
     [ScheduleId]               [int]              NOT NULL,
     [StartDt]                  [datetime]         NOT NULL,
     [EndDt]                    [datetime]         NOT NULL,
     [CurrentRecordFlag]        [tinyint]          NOT NULL CONSTRAINT [DF_SrvrInstncSchedJobScheduleMSSQL_CurrentRecordFlag] DEFAULT ((0)),
     [PackageExecutionId]       [bigint]           NOT NULL,
     [ScheduleDeletedFlag]      [tinyint]          NOT NULL CONSTRAINT [DF_SrvrInstncSchedJobScheduleMSSQL_ScheduleDeletedFlag] DEFAULT ((0)),
     [ScheduleIdentifier]       [uniqueidentifier]     NULL,
     [ScheduleName]             [varchar](128)     NOT NULL,
     [ScheduleOriginServerName] [varchar](128)     NOT NULL,
     [ScheduleOwnerName]        [varchar](128)     NOT NULL,
     [ScheduleEnabledFlag]      [tinyint]          NOT NULL,
     [ScheduleDescription]      [varchar](255)     NOT NULL,
     [ScheduleCrDt]             [datetime]         NOT NULL,
     [ScheduleLastModDt]        [datetime]             NULL,
     [ScheduleVersion]          [int]                  NULL,
     [CodedRawSchedule]         [varchar](120)     NOT NULL,
     CONSTRAINT [PK_SrvrInstncSchedJobScheduleMSSQL] PRIMARY KEY CLUSTERED 
     ( [SrvrInstncId] ASC, [SrvrInstncSchedJobId] ASC, [ScheduleId] ASC, [StartDt] ASC )
) ON [PRIMARY]
GO

SET ANSI_PADDING OFF
GO
